package com.orphan.marketBack.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.orphan.marketBack.po.dto.EacherDto;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;
import java.util.Map;


@Repository("echatMapper")
public interface EchatMapper extends BaseMapper<EacherDto> {
  @Select("SELECT ord.order_time , " +
          " SUM(ord.total_amount ) as sumorder " +
          " FROM order2 ord " +
          " GROUP BY ord.order_time " +
          " order by order_time asc")
  List<EacherDto> orderBY();

}
